Cooking - Ovens

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.StandardColor, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,if(p.CustomDescription IS NOT NULL AND p.CustomDescription <> '', p.CustomDescription, p.ModelDescription) AS ModelDescription,if(p.thumb LIKE 'http%',p.thumb, concat('/uploads/products/',p.thumb)) AS thumb ,if(p.large LIKE 'http%',p.large, concat('/uploads/products/',p.large)) AS large , mp.PowerBuy, mp.quick_ship, bd.preferred ,IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS SortPrice, bd.CommonBrandID,mh.super_category, mp.ge_inv FROM tbl_store_brands AS sb INNER JOIN Brand_Data AS bd ON bd.pkID = sb.brandID+0 INNER JOIN tbl_products AS p ON sb.categoryID = p.pkCategory AND sb.brandID = p.pkBrand INNER JOIN ModelPrice AS mp ON (p.SKU = mp.SKU AND p.pkSKU = mp.pkSKU) INNER JOIN menu_heading AS mh ON mh.slug = p.mhSlug WHERE p.mhSlug = 'cooking' AND cgSlug = 'ovens' AND mp.Available = 1 AND ((CommonBrandID = 'BOSC')) GROUP BY p.RootModelNumber ORDER BY IF(quick_ship =1,quick_ship,999999) ASC, FIELD(p.cSlug, 'grill-accessories') ASC, p.cSlug, display_sequence ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU
15
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 2
12 Last Page >>

Bosch500 Series, 30", Double Wall Oven, SS, Thermal/Thermal, Knob Control

Add To Compare

Bosch 500 Series, 30", Double Wall Oven, SS, Thermal/Thermal, Knob Control

Model Color Regular Price Savings After Savings
HBL5551UC Stainless Steel $3199.00 $300.00 $2,899.00
Bosch500 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Add To Compare

Bosch 500 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Model Color Regular Price Savings After Savings
HBL5651UC Stainless Steel $3549.00 $350.00 $3,199.00
Bosch800 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Add To Compare

Bosch 800 Series, 30", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Model Color Regular Price Savings After Savings
HBL8651UC Stainless Steel $3999.00 $400.00 $3,599.00
Bosch500 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Add To Compare

Bosch 500 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Knob Control

Model Color Regular Price Savings After Savings
HBN5651UC Stainless Steel $3549.00 $350.00 $3,199.00
Bosch800 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Add To Compare

Bosch 800 Series, 27", Double Wall Oven, SS, EU conv./Thermal, Touch Control

Model Color Regular Price Savings After Savings
HBN8651UC Stainless Steel $3999.00 $400.00 $3,599.00
Bosch800 Series Double Wall Oven 30'' Black Stainless Steel HBL8642UC

Add To Compare

Bosch 800 Series Double Wall Oven 30'' Black Stainless Steel HBL8642UC

Model Color Regular Price Savings After Savings
HBL8642UC Black Stainless Steel $4199.00 $400.00 $3,799.00
Bosch500 Series, 30", Single Wall Oven, SS, Thermal, Knob Control

Add To Compare

Bosch 500 Series, 30", Single Wall Oven, SS, Thermal, Knob Control

Model Color Regular Price Savings After Savings
HBL5351UC Stainless Steel $2099.00 $200.00 $1,899.00
Bosch500 Series, 30", Single Wall Oven, SS, EU Convection, Knob Control

Add To Compare

Bosch 500 Series, 30", Single Wall Oven, SS, EU Convection, Knob Control

Model Color Regular Price Savings After Savings
HBL5451UC Stainless Steel $2449.00 $250.00 $2,199.00
Bosch500 Series, 27", Single Wall Oven, SS, EU Convection, Knob Control

Add To Compare

Bosch 500 Series, 27", Single Wall Oven, SS, EU Convection, Knob Control

Model Color Regular Price Savings After Savings
HBN5451UC Stainless Steel $2449.00 $250.00 $2,199.00
Bosch800 Series, 27", Single Wall Oven, SS, EU Convection, Touch Control

Add To Compare

Bosch 800 Series, 27", Single Wall Oven, SS, EU Convection, Touch Control

Model Color Regular Price Savings After Savings
HBN8451UC Stainless Steel $2749.00 $250.00 $2,499.00
Bosch500 Series, 24", Singe Wall Oven, Wifi Connectivity, Touch Control

Add To Compare

Bosch 500 Series, 24", Singe Wall Oven, Wifi Connectivity, Touch Control

Model Color Regular Price Savings After Savings
HBE5452UC Stainless Steel $2349.00 $250.00 $2,099.00
Bosch800 Series Combination Oven 30'' Stainless Steel HBL8753UC

Add To Compare

Bosch 800 Series Combination Oven 30'' Stainless Steel HBL8753UC

Model Color Regular Price Savings After Savings
HBL8753UC Stainless Steel $5099.00 $500.00 $4,599.00
Bosch500 Series Single Wall Oven 24'' Stainless Steel HBE5453UC

Add To Compare

Bosch 500 Series Single Wall Oven 24'' Stainless Steel HBE5453UC

Model Color Regular Price Savings After Savings
HBE5453UC Stainless Steel $2099.00 $200.00 $1,899.00
Bosch800 Series Single Wall Oven 30'' Black Stainless Steel HBL8443UC

Add To Compare

Bosch 800 Series Single Wall Oven 30'' Black Stainless Steel HBL8443UC

Model Color Regular Price Savings After Savings
HBL8443UC Black Stainless Steel $3149.00 $300.00 $2,849.00
Bosch800 Series Single Wall Oven 30'' Stainless Steel HBL8453UC

Add To Compare

Bosch 800 Series Single Wall Oven 30'' Stainless Steel HBL8453UC

Model Color Regular Price Savings After Savings
HBL8453UC Stainless Steel $2949.00 $300.00 $2,649.00

Page 1 of 2
12 Last Page >>

Added to Cart
Model#
Enter Zip Code*For delivery options
Final discounts, tax, and shipping costs at checkout.